Excel List VDI 2048

This report is generated via the menu command "Data"à"Measured Data"à"Output"à"Validation Results (Excel)", when the Validation Method is set to "VDI 2048" or to "Lagrange".

However, it is also possible to generate this report automatically after each calculation. This setting is activated under "Extras"à"General Options" in the tab "Calculation" by checking the box "Store results of validation as ... Excel file".

The Excel report is always created in the same folder as the model file, with the name

            "Model_results.xls",

where "Model" is replaced by the actual name of your EBSILON^®Professional model. If this file already exists, it is overwritten without any message.

For creating the report, a template having the name "template_calculation_results_VDI2048.xls" is used, which is present in the folder specified under "Extras"->"General Options" in the tab "Paths" as the path for the Standard Excel Templates. You can also modify the layout here, if needed. However, you must note that in this report, EBSILON^®Professional enters its values always in certain cells only.

During the installation of EBSILON^®Professional, the Excel templates are offered in different languages. By changing the path setting (e.g. "GE" for German, "EN" for English, "FR" for French), you can define the language for your Excel reports regardless of the language setting for EBSILON^®Professional.

 

 

The header of the table contains the following:

• the type of calculation (here always validation)
• the name of the model (file name without the extension ".ebs")
• the date and the time of the calculation
• the name of the data set, unless the data set is read via an input file.
• the date and the time of the measured data, unless these are known from the input file or from the EPOS system
• the calculated mean square error (mean square error normalized to the number of the degrees of freedom as per equation 140 VDI 2048 sheet 1)
• the Chi^2-test ratio (relative mean square error divided by the value of the Fisher-distribution)

The table contains a list of all the measurement points available in the model, one row for each measurement point.

Hint: If in your model you use components as pure graphics, which are not included in the EBSILON^®Professional calculation, you can set, whether these are to be included in the validation list or not. This is done by making a selection on the tab "Extended Options" of the property sheet of the measurement point. Including such measurement points not calculated by EBSILON^®Professional can be helpful when these are otherwise filled with useful data via the EPOS system or EbsScript.

 

The columns in the table show:

• the index of the measurement point (important for specifying the strongest correlation),
• the name of the measurement point,
• the description of the measurement point (if entered),
• the unit (the list always shows the unit, which can also be seen on the screen),
• the measured value (specification value MEASM),
• the validated value (result value RESULT),
• the relative deviation of the measurement value from the calculated value (specification value DEV) in %
• the confidence interval of the measurement value (specification value MCONF),
• the confidence interval of the validated value (specification value RCONF),
• the value of the strongest correlation (specification value CORR) in % (factor 100),
• the index of the measurement value, for which there is the strongest correlation as per the equation 129 of the guideline VDI 2048 sheet 1(specification value CORRMAX),
• deviation according to equation 141 VDI 2048 sheet 1 in % (factor 100)
• the status of the measurement point (specification value FSTAT, see Results for measurement points)
• the identification "?" for too high deviations as per equation 141 VDI 2048 sheet 1.